<?php

use Illuminate\Database\Migrations\Migration;

class CreateHoidongxetduyetTable extends Migration
{
    /**
    * Run the migrations.
    *
    * @return void
    */
    public function up()
    {
        Schema::create('hoi_dong_xet_duyet', function($table)
        {
            $table->engine='InnoDB';
            $table->increments('id')->unsigned();
            $table->string('ma_so_hoi_dong', 10)->unique();
            $table->integer('id_de_tai')->unsigned();
            $table->datetime('thoi_gian_lap');
            $table->datetime('thoi_gian_xd');
        });
    }

    /**
    * reverse the migrations.
    *
    * @return void
    */
    public function down()
    {
        Schema::drop('hoi_dong_xet_duyet');
    }
}